1 <?php
2 require("../includes/config.php");
3 include("../includes/validate_data.php");
4 error_reporting(0);
5 session_start();
6 if(isset($_SESSION['manufacturer_login'])) {
7 $error = "";
8 $querySelectRetailer = "SELECT *,area.area_id AS area_id FROM retailer,area WHERE retailer.area_id = area.area_id";
9 $resultSelectRetailer = mysqli_query($con,$querySelectRetailer);
10 if($_SERVER['REQUEST_METHOD'] == "POST") {
11 if(isset($_POST['cmbFilter'])) {
12 if(!empty($_POST['txtId'])) {
13 $result = validate_number($_POST['txtId']);
14 if($result == 1) {
15 $order_id = $_POST['txtId'];
16 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND order_id='$order_id'";
17 $result_selectOrder = mysqli_query($con,$query_selectOrder);
18 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
19 if(empty($row_selectOrder)){
20 $error = "* No order was found with this ID";
21 }
22 else {
23 mysqli_data_seek($result_selectOrder,0);
24 }
25 }
26 else {
27 $error = "* Invalid ID";
28 }
29 }
30 else if(!empty($_POST['cmbRetailer'])) {
31 $retailer_id = $_POST['cmbRetailer'];
32 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND orders.retailer_id='$retailer_id' ORDER BY approved,status,order_id DESC";
33 $result_selectOrder = mysqli_query($con,$query_selectOrder);
34 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
35 if(empty($row_selectOrder)){
36 $error = "* No order was found of the selected Retailer";
37 }
38 else {
39 mysqli_data_seek($result_selectOrder,0);
40 }
41 }
42 else if(!empty($_POST['txtDate'])) {
43 $date = $_POST['txtDate'];
44 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND date='$date'";
45 $result_selectOrder = mysqli_query($con,$query_selectOrder);
46 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
47 if(empty($row_selectOrder)){
48 $error = "* No order was found with the selected Date";
49 }
50 else {
51 mysqli_data_seek($result_selectOrder,0);
52 }
53
54 }
55 else if(!empty($_POST['cmbStatus'])) {
56 if($_POST['cmbStatus'] == "zero") {
57 $status = 0;
58 }
59 else {
60 $status = $_POST['cmbStatus'];
61 }
62 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND status='$status' ORDER BY approved,order_id DESC";
63 $result_selectOrder = mysqli_query($con,$query_selectOrder);
64 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
65 if(empty($row_selectOrder)){
66 $error = "* No order was found";
67 }
68 else {
69 mysqli_data_seek($result_selectOrder,0);
70 }
71 }
72 else if(!empty($_POST['cmbApproved'])) {
73 if($_POST['cmbStatus'] == "zero") {
74 $approved = 0;
75 }
76 else {
77 $approved = $_POST['cmbApproved'];
78 }
79 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND approved='$approved' ORDER BY order_id DESC";
80 $result_selectOrder = mysqli_query($con,$query_selectOrder);
81 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
82 if(empty($row_selectOrder)){
83 $error = "* No order was found";
84 }
85 else {
86 mysqli_data_seek($result_selectOrder,0);
87 }
88 }
89 else {
90 $error = "* Please enter the data to search for.";
91 }
92 }
93 else {
94 $error = "Please choose an option to search for.";
95 }
96 }
97 else {
98 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id ORDER BY approved,status,order_id DESC;";
99 $result_selectOrder = mysqli_query($con,$query_selectOrder);
100 }
101 }
102 else {
103 header('Location:../index.php');
104 }
105 ?>
106
107 <!DOCTYPE html>
108 <html>
109 <head>
110 <title> View Orders </title>
111 <link rel="stylesheet" href="../includes/main_style.css" >
112 <link rel="stylesheet" href="css/smoothness/jquery-ui.css">
113 <script type="text/javascript" src="../includes/jquery.js"> </script>
114 <script src="js/jquery-ui.js"></script>
115 <script>
116 $(function() {
117 $( "#datepicker" ).datepicker({
118 changeMonth:true,
119 changeYear:true,
120 yearRange:"-100:+0",
121 dateFormat:"yy-mm-dd"
122 });
123 });
124 </script>
125 </head>
126 <body>
127 <?php
128 include("../includes/header.inc.php");
129 include("../includes/nav_manufacturer.inc.php");
130 include("../includes/aside_manufacturer.inc.php");
131 ?>
132 <section>
133 <h1>Orders</h1>
134 <form action="" method="POST" class="form">
135 Search By:
136 <div class="input-box">
137 <select name="cmbFilter" id="cmbFilter">
138 <option value="" disabled selected>-- Search By --</option>
139 <option value="id"> Id </option>
140 <option value="retailer"> Retailer </option>
141 <option value="date"> Date </option>
142 <option value="status"> Status </option>
143 <option value="approved"> Approval </option>
144 </select>
145 </div>
146
147 <div class="input-box"> <input type="text" name="txtId" id="txtId" style="display:none;" /> </div>
148 <div class="input-box">
149 <select name="cmbRetailer" id="cmbRetailer" style="display:none;">
150 <option value="" disabled selected>-- Select Retailer --</option>
151 <?php while($rowSelectRetailer = mysqli_fetch_array($resultSelectRetailer)) { ?>
152 <option value="<?php echo $rowSelectRetailer['retailer_id']; ?>"><?php echo $rowSelectRetailer['area_code']." (".$rowSelectRetailer['area_name'].")"; ?></option>
153 <?php } ?>
154 </select>
155 </div>
156 <div class="input-box"> <input type="text" id="datepicker" name="txtDate" style="display:none;"/> </div>
157 <div class="input-box">
158 <select name="cmbStatus" id="cmbStatus" style="display:none;">
159 <option value="" disabled selected>-- Select Option --</option>
160 <option value="zero"> Pending </option>
161 <option value="1"> Completed </option>
162 </select>
163 </div>
164 <div class="input-box">
165 <select name="cmbApproved" id="cmbApproved" style="display:none;">
166 <option value="" disabled selected>-- Select Option --</option>
167 <option value="zero"> Not Approved </option>
168 <option value="1"> Approved </option>
169 </select>
170 </div>
171
172 <input type="submit" class="submit_button" value="Search" /> <span class="error_message"> <?php echo $error; ?> </span>
173 </form>
174 <form action="" method="POST" class="form">
175 <table class="table_displayData" style="margin-top:20px;">
176 <tr>
177 <th> Order ID </th>
178 <th> Retailer </th>
179 <th> Date </th>
180 <th> Approved Status </th>
181 <th> Order Status </th>
182 <th> Details </th>
183 <th> Confirm </th>
184 <th> Generate Invoice </th>
185 </tr>
186 <?php $i=1; while($row_selectOrder = mysqli_fetch_array($result_selectOrder)) { ?>
187 <tr>
188
189 <td> <?php echo $row_selectOrder['order_id']; ?> </td>
190 <td> <?php echo $row_selectOrder['area_code']; ?> </td>
191
192 <td> <?php echo date("d-m-Y",strtotime($row_selectOrder['date'])); ?> </td>
193 <td>
194 <?php
195 if($row_selectOrder['approved'] == 0) {
196 echo "Not Approved";
197 }
198 else {
199 echo "Approved";
200 }
201 ?>
202 </td>
203 <td>
204 <?php
205 if($row_selectOrder['status'] == 0) {
206 echo "Pending";
207 }
208 else {
209 echo "Completed";
210 }
211 ?>
212 </td>
213 <td> <a href="view_order_items.php?id=<?php echo $row_selectOrder['order_id']; ?>">Details</a> </td>
214 <td>
215 <?php
216 if($row_selectOrder['approved'] == 0) {
217 echo "<a href=\"confirm_order.php?id=".$row_selectOrder['order_id']."\">Confirm</a>";
218 }
219 else {
220
221 }
222 ?>
223 </td>
224 <td>
225 <?php
226 if($row_selectOrder['approved'] == 1 && $row_selectOrder['status'] == 0) {
227 ?>
228 <a href="generate_invoice.php?id=<?php echo $row_selectOrder['order_id']; ?>">+ Invoice</a>
229 <?php
230 }
231 ?>
232 </td>
233 </tr>
234 <?php $i++; } ?>
235 </table>
236 </form>
237 </section>
238 <?php
239 include("../includes/footer.inc.php");
240 ?>
241 <script type="text/javascript">
242 $('#cmbFilter').change(function() {
243 var selected = $(this).val();
244 if(selected == "id"){
245 $('#txtId').show();
246 $('#cmbRetailer').hide();
247 $('#datepicker').hide();
248 $('#cmbStatus').hide();
249 $('#cmbApproved').hide();
250 }
251 else if (selected == "retailer"){
252 $('#txtId').hide();
253 $('#cmbRetailer').show();
254 $('#datepicker').hide();
255 $('#cmbStatus').hide();
256 $('#cmbApproved').hide();
257 }
258 else if (selected == "date"){
259 $('#txtId').hide();
260 $('#cmbRetailer').hide();
261 $('#datepicker').show();
262 $('#cmbStatus').hide();
263 $('#cmbApproved').hide();
264 }
265 else if (selected == "status"){
266 $('#txtId').hide();
267 $('#cmbRetailer').hide();
268 $('#datepicker').hide();
269 $('#cmbStatus').show();
270 $('#cmbApproved').hide();
271 }
272 else if (selected == "approved"){
273 $('#txtId').hide();
274 $('#cmbRetailer').hide();
275 $('#datepicker').hide();
276 $('#cmbStatus').hide();
277 $('#cmbApproved').show();
278 }
279 });
280 </script>
281 </body>
282 </html>